Dataset statistics
| Number of variables | 44 |
|---|---|
| Number of observations | 198 |
| Missing cells | 3197 |
| Missing cells (%) | 36.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 68.2 KiB |
| Average record size in memory | 352.6 B |
Variable types
| CAT | 21 |
|---|---|
| NUM | 12 |
| DATE | 4 |
| UNSUPPORTED | 4 |
| BOOL | 3 |
Select project has constant value "198" | Constant |
FR1_ProjectName has constant value "198" | Constant |
FR3 Area Units has constant value "198" | Constant |
Asset ID: has a high cardinality: 194 distinct values | High cardinality |
Asset Description has a high cardinality: 195 distinct values | High cardinality |
Comments has a high cardinality: 79 distinct values | High cardinality |
Bund height (m) is highly correlated with ObjectID and 4 other fields | High correlation |
ObjectID is highly correlated with Bund height (m) and 1 other fields | High correlation |
Bund width (m) is highly correlated with Installed Cost (£) and 1 other fields | High correlation |
Installed Cost (£) is highly correlated with Bund width (m) | High correlation |
Bund length (m) is highly correlated with ObjectID and 3 other fields | High correlation |
Storage Created (m3) is highly correlated with Bund width (m) and 1 other fields | High correlation |
FR3_AreaRough is highly correlated with Storage Created (m3) | High correlation |
longitude is highly correlated with Bund height (m) and 1 other fields | High correlation |
latitude is highly correlated with Bund height (m) and 1 other fields | High correlation |
log10_price is highly correlated with Bund height (m) | High correlation |
Watercourse Type has 5 (2.5%) missing values | Missing |
Stream Width (m) has 42 (21.2%) missing values | Missing |
Land Drainage Consent Difficulty has 10 (5.1%) missing values | Missing |
Ecological Consent Difficulty has 13 (6.6%) missing values | Missing |
Average member length in Leaky Barrier (m) has 41 (20.7%) missing values | Missing |
Wood Diameter (cm) has 66 (33.3%) missing values | Missing |
Height of Leaky Barrier above bed (cm) has 44 (22.2%) missing values | Missing |
Height of Leaky Barrier above bank (cm) has 115 (58.1%) missing values | Missing |
Wood Species Used has 170 (85.9%) missing values | Missing |
Other Wood Species has 190 (96.0%) missing values | Missing |
Bund height (m) has 194 (98.0%) missing values | Missing |
Bund width (m) has 194 (98.0%) missing values | Missing |
Bund length (m) has 194 (98.0%) missing values | Missing |
Bund Material has 189 (95.5%) missing values | Missing |
Gully Block Length (m) has 198 (100.0%) missing values | Missing |
Gully Block Width (m) has 198 (100.0%) missing values | Missing |
Gully Block Material has 198 (100.0%) missing values | Missing |
Soil Equipment or Technique Used has 198 (100.0%) missing values | Missing |
Flood Efficacy has 37 (18.7%) missing values | Missing |
FR3_AreaRough has 190 (96.0%) missing values | Missing |
Storage Created (m3) has 3 (1.5%) missing values | Missing |
FR3_AreaIncreasedLoss has 195 (98.5%) missing values | Missing |
Changed Flood Pathway? has 66 (33.3%) missing values | Missing |
Reduced Erosion? has 155 (78.3%) missing values | Missing |
Asset Condition has 13 (6.6%) missing values | Missing |
Date Assessed has 11 (5.6%) missing values | Missing |
Comments has 84 (42.4%) missing values | Missing |
Creator has 172 (86.9%) missing values | Missing |
Editor has 12 (6.1%) missing values | Missing |
Asset ID: is uniformly distributed | Uniform |
Asset Description is uniformly distributed | Uniform |
ObjectID has unique values | Unique |
GlobalID has unique values | Unique |
CreationDate has unique values | Unique |
longitude has unique values | Unique |
latitude has unique values | Unique |
Gully Block Length (m) is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Gully Block Width (m) is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Gully Block Material is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Soil Equipment or Technique Used is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Installed Cost (£) has 3 (1.5%) zeros | Zeros |
Height of Leaky Barrier above bed (cm) has 3 (1.5%) zeros | Zeros |
Height of Leaky Barrier above bank (cm) has 42 (21.2%) zeros | Zeros |
FR3_AreaRough has 3 (1.5%) zeros | Zeros |
Storage Created (m3) has 2 (1.0%) zeros | Zeros |
Reproduction
| Analysis started | 2020-10-13 23:17:27.362610 |
|---|---|
| Analysis finished | 2020-10-13 23:18:15.679643 |
| Duration | 48.32 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 198 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 677.5050505 |
|---|---|
| Minimum | 42 |
| Maximum | 1254 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 42 |
|---|---|
| 5-th percentile | 289.85 |
| Q1 | 454.25 |
| median | 650.5 |
| Q3 | 718.75 |
| 95-th percentile | 1211 |
| Maximum | 1254 |
| Range | 1212 |
| Interquartile range (IQR) | 264.5 |
Descriptive statistics
| Standard deviation | 292.2571663 |
|---|---|
| Coefficient of variation (CV) | 0.4313726755 |
| Kurtosis | -0.4231717337 |
| Mean | 677.5050505 |
| Median Absolute Deviation (MAD) | 190 |
| Skewness | 0.4629322464 |
| Sum | 134146 |
| Variance | 85414.25124 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1122 | 1 | 0.5% | |
| 674 | 1 | 0.5% | |
| 670 | 1 | 0.5% | |
| 669 | 1 | 0.5% | |
| 668 | 1 | 0.5% | |
| 667 | 1 | 0.5% | |
| 666 | 1 | 0.5% | |
| 665 | 1 | 0.5% | |
| 664 | 1 | 0.5% | |
| 619 | 1 | 0.5% | |
| Other values (188) | 188 | 94.9% |
| Value | Count | Frequency (%) | |
| 42 | 1 | 0.5% | |
| 90 | 1 | 0.5% | |
| 91 | 1 | 0.5% | |
| 92 | 1 | 0.5% | |
| 93 | 1 | 0.5% |
| Value | Count | Frequency (%) | |
| 1254 | 1 | 0.5% | |
| 1253 | 1 | 0.5% | |
| 1252 | 1 | 0.5% | |
| 1251 | 1 | 0.5% | |
| 1250 | 1 | 0.5% |
| Distinct | 198 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| cbf127d8-106a-4d9d-949c-473b3078ad42 | 1 |
|---|---|
| 6f0e9956-8d95-4ebf-a540-9f0cabc735e9 | 1 |
| 945b0df9-3996-4d09-8b0f-b0ab40ae8198 | 1 |
| c53075f1-4e5b-4885-b250-feecdaa6493e | 1 |
| d29a1053-7fe8-4a50-9403-74ccbd4e45fb | 1 |
| Other values (193) |
| Value | Count | Frequency (%) | |
| cbf127d8-106a-4d9d-949c-473b3078ad42 | 1 | 0.5% | |
| 6f0e9956-8d95-4ebf-a540-9f0cabc735e9 | 1 | 0.5% | |
| 945b0df9-3996-4d09-8b0f-b0ab40ae8198 | 1 | 0.5% | |
| c53075f1-4e5b-4885-b250-feecdaa6493e | 1 | 0.5% | |
| d29a1053-7fe8-4a50-9403-74ccbd4e45fb | 1 | 0.5% | |
| 1d32eb4f-29cb-4dd9-8e9c-4d94d643dc02 | 1 | 0.5% | |
| 28d45f34-03aa-425c-a28a-ede44093cc79 | 1 | 0.5% | |
| ec128f1e-7bdb-433c-8566-70459f0584a3 | 1 | 0.5% | |
| aae98524-b3a9-4337-8ff5-88ed44dc2b31 | 1 | 0.5% | |
| 6bb19f39-da8c-4e6a-95d4-d202ba6611ad | 1 | 0.5% | |
| Other values (188) | 188 | 94.9% |
Unique
| Unique | 198 ? |
|---|---|
| Unique (%) | 100.0% |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| A017 |
|---|
| Value | Count | Frequency (%) | |
| A017 | 198 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| Shipston |
|---|
| Value | Count | Frequency (%) | |
| Shipston | 198 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
| Distinct | 194 |
|---|---|
| Distinct (%) | 98.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| A017_2002131359 | 2 |
|---|---|
| A017_2005041404 | 2 |
| A017_2003021344 | 2 |
| A017_2004271037 | 2 |
| A017_2005131053 | 1 |
| Other values (189) |
| Value | Count | Frequency (%) | |
| A017_2002131359 | 2 | 1.0% | |
| A017_2005041404 | 2 | 1.0% | |
| A017_2003021344 | 2 | 1.0% | |
| A017_2004271037 | 2 | 1.0% | |
| A017_2005131053 | 1 | 0.5% | |
| A017_1912312004 | 1 | 0.5% | |
| A017_2008151115 | 1 | 0.5% | |
| A017_2002131410 | 1 | 0.5% | |
| A017_2010071449 | 1 | 0.5% | |
| A017_2004271022 | 1 | 0.5% | |
| Other values (184) | 184 | 92.9% |
Unique
| Unique | 190 ? |
|---|---|
| Unique (%) | 96.0% |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Asset Type
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| leaky_barriers | |
|---|---|
| offline_storage_areas | |
| runoff_pathway_management | 12 |
| riparian_woodland_creation | 1 |
| river_restoration | 1 |
| Value | Count | Frequency (%) | |
| leaky_barriers | 165 | 83.3% | |
| offline_storage_areas | 18 | 9.1% | |
| runoff_pathway_management | 12 | 6.1% | |
| riparian_woodland_creation | 1 | 0.5% | |
| river_restoration | 1 | 0.5% | |
| cross_slope_woodland_creation | 1 | 0.5% |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 1.5% |
Length
| Max length | 29 |
|---|---|
| Median length | 14 |
| Mean length | 15.45454545 |
| Min length | 14 |
| Distinct | 195 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| DELETE | 4 |
|---|---|
| KNEEBATS08LB5 | 1 |
| KNEECOMP04LB3 | 1 |
| KNEEBEECH02LB1 | 1 |
| KNEELONG51LB51 | 1 |
| Other values (190) |
| Value | Count | Frequency (%) | |
| DELETE | 4 | 2.0% | |
| KNEEBATS08LB5 | 1 | 0.5% | |
| KNEECOMP04LB3 | 1 | 0.5% | |
| KNEEBEECH02LB1 | 1 | 0.5% | |
| KNEELONG51LB51 | 1 | 0.5% | |
| KNEELONG07LB7 | 1 | 0.5% | |
| KNEELONG36LB36 | 1 | 0.5% | |
| KNEELONG37LB37 | 1 | 0.5% | |
| KNEELONG22LB22 | 1 | 0.5% | |
| Hen1 | 1 | 0.5% | |
| Other values (185) | 185 | 93.4% |
Unique
| Unique | 194 ? |
|---|---|
| Unique (%) | 98.0% |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 12.52020202 |
| Min length | 1 |
Date Installed
Date
| Distinct | 48 |
|---|---|
| Distinct (%) | 24.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| Minimum | 2017-05-31 12:00:00 |
|---|---|
| Maximum | 2020-10-07 11:00:00 |
| Distinct | 25 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 283.2828283 |
|---|---|
| Minimum | 0 |
| Maximum | 6000 |
| Zeros | 3 |
| Zeros (%) | 1.5% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 100 |
| median | 100 |
| Q3 | 150 |
| 95-th percentile | 1560 |
| Maximum | 6000 |
| Range | 6000 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 697.2500231 |
|---|---|
| Coefficient of variation (CV) | 2.461321173 |
| Kurtosis | 30.48896583 |
| Mean | 283.2828283 |
| Median Absolute Deviation (MAD) | 50 |
| Skewness | 5.060124046 |
| Sum | 56090 |
| Variance | 486157.5947 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 100 | 65 | 32.8% | |
| 1 | 30 | 15.2% | |
| 150 | 23 | 11.6% | |
| 120 | 22 | 11.1% | |
| 60 | 10 | 5.1% | |
| 230 | 9 | 4.5% | |
| 160 | 7 | 3.5% | |
| 260 | 5 | 2.5% | |
| 200 | 5 | 2.5% | |
| 0 | 3 | 1.5% | |
| Other values (15) | 19 | 9.6% |
| Value | Count | Frequency (%) | |
| 0 | 3 | 1.5% | |
| 1 | 30 | 15.2% | |
| 60 | 10 | 5.1% | |
| 100 | 65 | 32.8% | |
| 120 | 22 | 11.1% |
| Value | Count | Frequency (%) | |
| 6000 | 1 | 0.5% | |
| 4000 | 1 | 0.5% | |
| 3800 | 1 | 0.5% | |
| 2670 | 1 | 0.5% | |
| 2155 | 2 | 1.0% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 5 |
| Missing (%) | 2.5% |
| Memory size | 1.5 KiB |
| ordinary |
|---|
| Value | Count | Frequency (%) | |
| ordinary | 193 | 97.5% | |
| (Missing) | 5 | 2.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.873737374 |
| Min length | 3 |
| Distinct | 12 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 42 |
| Missing (%) | 21.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.510897436 |
|---|---|
| Minimum | 0.5 |
| Maximum | 38 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 0.6 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1.5 |
| 95-th percentile | 2 |
| Maximum | 38 |
| Range | 37.5 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 2.985736495 |
|---|---|
| Coefficient of variation (CV) | 1.976134464 |
| Kurtosis | 146.5455001 |
| Mean | 1.510897436 |
| Median Absolute Deviation (MAD) | 0.25 |
| Skewness | 11.93046713 |
| Sum | 235.7 |
| Variance | 8.914622415 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 71 | 35.9% | |
| 1.5 | 39 | 19.7% | |
| 2 | 20 | 10.1% | |
| 0.75 | 8 | 4.0% | |
| 0.5 | 6 | 3.0% | |
| 0.6 | 3 | 1.5% | |
| 3 | 3 | 1.5% | |
| 1.25 | 2 | 1.0% | |
| 1.2 | 1 | 0.5% | |
| 0.7 | 1 | 0.5% | |
| Other values (2) | 2 | 1.0% | |
| (Missing) | 42 | 21.2% |
| Value | Count | Frequency (%) | |
| 0.5 | 6 | 3.0% | |
| 0.6 | 3 | 1.5% | |
| 0.7 | 1 | 0.5% | |
| 0.75 | 8 | 4.0% | |
| 1 | 71 | 35.9% |
| Value | Count | Frequency (%) | |
| 38 | 1 | 0.5% | |
| 4 | 1 | 0.5% | |
| 3 | 3 | 1.5% | |
| 2 | 20 | 10.1% | |
| 1.5 | 39 | 19.7% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 10 |
| Missing (%) | 5.1% |
| Memory size | 1.5 KiB |
| easy | |
|---|---|
| moderate | 11 |
| n_a | 3 |
| Value | Count | Frequency (%) | |
| easy | 174 | 87.9% | |
| moderate | 11 | 5.6% | |
| n_a | 3 | 1.5% | |
| (Missing) | 10 | 5.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 4.156565657 |
| Min length | 3 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 13 |
| Missing (%) | 6.6% |
| Memory size | 1.5 KiB |
| n_a | |
|---|---|
| easy | 11 |
| moderate | 1 |
| Value | Count | Frequency (%) | |
| n_a | 173 | 87.4% | |
| easy | 11 | 5.6% | |
| moderate | 1 | 0.5% | |
| (Missing) | 13 | 6.6% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.5% |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 3.080808081 |
| Min length | 3 |
| Distinct | 12 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 41 |
| Missing (%) | 20.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.573248408 |
|---|---|
| Minimum | 1.5 |
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 1.5 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2.5 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 8 |
| Maximum | 15 |
| Range | 13.5 |
| Interquartile range (IQR) | 1.5 |
Descriptive statistics
| Standard deviation | 1.843052866 |
|---|---|
| Coefficient of variation (CV) | 0.5157919786 |
| Kurtosis | 10.43237514 |
| Mean | 3.573248408 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.63726579 |
| Sum | 561 |
| Variance | 3.396843867 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3 | 44 | 22.2% | |
| 2 | 28 | 14.1% | |
| 2.5 | 23 | 11.6% | |
| 4 | 22 | 11.1% | |
| 5 | 11 | 5.6% | |
| 6 | 9 | 4.5% | |
| 3.5 | 8 | 4.0% | |
| 8 | 6 | 3.0% | |
| 1.5 | 2 | 1.0% | |
| 10 | 2 | 1.0% | |
| Other values (2) | 2 | 1.0% | |
| (Missing) | 41 | 20.7% |
| Value | Count | Frequency (%) | |
| 1.5 | 2 | 1.0% | |
| 2 | 28 | 14.1% | |
| 2.5 | 23 | 11.6% | |
| 3 | 44 | 22.2% | |
| 3.5 | 8 | 4.0% |
| Value | Count | Frequency (%) | |
| 15 | 1 | 0.5% | |
| 10 | 2 | 1.0% | |
| 8 | 6 | 3.0% | |
| 6 | 9 | 4.5% | |
| 5 | 11 | 5.6% |
| Distinct | 13 |
|---|---|
| Distinct (%) | 9.8% |
| Missing | 66 |
| Missing (%) | 33.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.57575758 |
|---|---|
| Minimum | 1 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 15 |
| median | 20 |
| Q3 | 25 |
| 95-th percentile | 34.5 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 11.07219281 |
|---|---|
| Coefficient of variation (CV) | 0.5131774757 |
| Kurtosis | 19.258222 |
| Mean | 21.57575758 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 3.197978006 |
| Sum | 2848 |
| Variance | 122.5934536 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 15 | 34 | 17.2% | |
| 25 | 27 | 13.6% | |
| 20 | 26 | 13.1% | |
| 30 | 20 | 10.1% | |
| 10 | 14 | 7.1% | |
| 40 | 3 | 1.5% | |
| 7.5 | 2 | 1.0% | |
| 60 | 1 | 0.5% | |
| 1 | 1 | 0.5% | |
| 50 | 1 | 0.5% | |
| Other values (3) | 3 | 1.5% | |
| (Missing) | 66 | 33.3% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.5% | |
| 7.5 | 2 | 1.0% | |
| 10 | 14 | 7.1% | |
| 12 | 1 | 0.5% | |
| 15 | 34 | 17.2% |
| Value | Count | Frequency (%) | |
| 100 | 1 | 0.5% | |
| 60 | 1 | 0.5% | |
| 50 | 1 | 0.5% | |
| 45 | 1 | 0.5% | |
| 40 | 3 | 1.5% |
| Distinct | 18 |
|---|---|
| Distinct (%) | 11.7% |
| Missing | 44 |
| Missing (%) | 22.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.7012987 |
|---|---|
| Minimum | 0 |
| Maximum | 200 |
| Zeros | 3 |
| Zeros (%) | 1.5% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 60 |
| Maximum | 200 |
| Range | 200 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 24.68967657 |
|---|---|
| Coefficient of variation (CV) | 0.9246620115 |
| Kurtosis | 19.58612368 |
| Mean | 26.7012987 |
| Median Absolute Deviation (MAD) | 7.5 |
| Skewness | 3.681385316 |
| Sum | 4112 |
| Variance | 609.580129 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 15 | 49 | 24.7% | |
| 30 | 21 | 10.6% | |
| 20 | 15 | 7.6% | |
| 25 | 13 | 6.6% | |
| 10 | 12 | 6.1% | |
| 60 | 9 | 4.5% | |
| 45 | 7 | 3.5% | |
| 40 | 7 | 3.5% | |
| 35 | 4 | 2.0% | |
| 100 | 3 | 1.5% | |
| Other values (8) | 14 | 7.1% | |
| (Missing) | 44 | 22.2% |
| Value | Count | Frequency (%) | |
| 0 | 3 | 1.5% | |
| 1 | 3 | 1.5% | |
| 1.5 | 1 | 0.5% | |
| 5 | 3 | 1.5% | |
| 7.5 | 1 | 0.5% |
| Value | Count | Frequency (%) | |
| 200 | 1 | 0.5% | |
| 150 | 1 | 0.5% | |
| 100 | 3 | 1.5% | |
| 60 | 9 | 4.5% | |
| 50 | 1 | 0.5% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 19.3% |
| Missing | 115 |
| Missing (%) | 58.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.01686747 |
|---|---|
| Minimum | 0 |
| Maximum | 1050 |
| Zeros | 42 |
| Zeros (%) | 21.2% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 30 |
| 95-th percentile | 100 |
| Maximum | 1050 |
| Range | 1050 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 118.7153521 |
|---|---|
| Coefficient of variation (CV) | 3.390233357 |
| Kurtosis | 67.06044716 |
| Mean | 35.01686747 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.846383132 |
| Sum | 2906.4 |
| Variance | 14093.33483 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 42 | 21.2% | |
| 15 | 8 | 4.0% | |
| 100 | 7 | 3.5% | |
| 50 | 6 | 3.0% | |
| 20 | 5 | 2.5% | |
| 30 | 4 | 2.0% | |
| 45 | 2 | 1.0% | |
| 110 | 1 | 0.5% | |
| 25 | 1 | 0.5% | |
| 5 | 1 | 0.5% | |
| Other values (6) | 6 | 3.0% | |
| (Missing) | 115 | 58.1% |
| Value | Count | Frequency (%) | |
| 0 | 42 | 21.2% | |
| 0.2 | 1 | 0.5% | |
| 1.2 | 1 | 0.5% | |
| 5 | 1 | 0.5% | |
| 10 | 1 | 0.5% |
| Value | Count | Frequency (%) | |
| 1050 | 1 | 0.5% | |
| 200 | 1 | 0.5% | |
| 110 | 1 | 0.5% | |
| 100 | 7 | 3.5% | |
| 75 | 1 | 0.5% |
| Distinct | 4 |
|---|---|
| Distinct (%) | 14.3% |
| Missing | 170 |
| Missing (%) | 85.9% |
| Memory size | 1.5 KiB |
| willow_dead | |
|---|---|
| other | |
| softwood | 1 |
| willow_live | 1 |
| Value | Count | Frequency (%) | |
| willow_dead | 18 | 9.1% | |
| other | 8 | 4.0% | |
| softwood | 1 | 0.5% | |
| willow_live | 1 | 0.5% | |
| (Missing) | 170 | 85.9% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 7.1% |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 3.873737374 |
| Min length | 3 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 25.0% |
| Missing | 190 |
| Missing (%) | 96.0% |
| Memory size | 1.5 KiB |
| Leylandi | |
|---|---|
| Machined |
| Value | Count | Frequency (%) | |
| Leylandi | 6 | 3.0% | |
| Machined | 2 | 1.0% | |
| (Missing) | 190 | 96.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 3.202020202 |
| Min length | 3 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 194 |
| Missing (%) | 98.0% |
| Memory size | 1.5 KiB |
| 2 | |
|---|---|
| 0.6 | |
| 2.5 |
| Value | Count | Frequency (%) | |
| 2 | 2 | 1.0% | |
| 0.6 | 1 | 0.5% | |
| 2.5 | 1 | 0.5% | |
| (Missing) | 194 | 98.0% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 50.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 194 |
| Missing (%) | 98.0% |
| Memory size | 1.5 KiB |
| 3 | |
|---|---|
| 30 | |
| 1 |
| Value | Count | Frequency (%) | |
| 3 | 2 | 1.0% | |
| 30 | 1 | 0.5% | |
| 1 | 1 | 0.5% | |
| (Missing) | 194 | 98.0% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 50.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.005050505 |
| Min length | 3 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 194 |
| Missing (%) | 98.0% |
| Memory size | 1.5 KiB |
| 1 | |
|---|---|
| 2 | |
| 12 |
| Value | Count | Frequency (%) | |
| 1 | 2 | 1.0% | |
| 2 | 1 | 0.5% | |
| 12 | 1 | 0.5% | |
| (Missing) | 194 | 98.0% |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 50.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.005050505 |
| Min length | 3 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 11.1% |
| Missing | 189 |
| Missing (%) | 95.5% |
| Memory size | 1.5 KiB |
| clay |
|---|
| Value | Count | Frequency (%) | |
| clay | 9 | 4.5% | |
| (Missing) | 189 | 95.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.045454545 |
| Min length | 3 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 37 |
| Missing (%) | 18.7% |
| Memory size | 1.5 KiB |
| moderate | |
|---|---|
| high | |
| low | 12 |
| Value | Count | Frequency (%) | |
| moderate | 134 | 67.7% | |
| high | 15 | 7.6% | |
| low | 12 | 6.1% | |
| (Missing) | 37 | 18.7% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 6.45959596 |
| Min length | 3 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| ha |
|---|
| Value | Count | Frequency (%) | |
| ha | 198 | 100.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 62.5% |
| Missing | 190 |
| Missing (%) | 96.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5875 |
|---|---|
| Minimum | 0 |
| Maximum | 2 |
| Zeros | 3 |
| Zeros (%) | 1.5% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1 |
| Q3 | 1.125 |
| 95-th percentile | 1.825 |
| Maximum | 2 |
| Range | 2 |
| Interquartile range (IQR) | 1.125 |
Descriptive statistics
| Standard deviation | 0.8025628591 |
|---|---|
| Coefficient of variation (CV) | 1.366064441 |
| Kurtosis | -0.6247378549 |
| Mean | 0.5875 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 1.034701614 |
| Sum | 4.7 |
| Variance | 0.6441071429 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 3 | 1.5% | |
| 0.1 | 2 | 1.0% | |
| 2 | 1 | 0.5% | |
| 1.5 | 1 | 0.5% | |
| 1 | 1 | 0.5% | |
| (Missing) | 190 | 96.0% |
| Value | Count | Frequency (%) | |
| 0 | 3 | 1.5% | |
| 0.1 | 2 | 1.0% | |
| 1 | 1 | 0.5% | |
| 1.5 | 1 | 0.5% | |
| 2 | 1 | 0.5% |
| Value | Count | Frequency (%) | |
| 2 | 1 | 0.5% | |
| 1.5 | 1 | 0.5% | |
| 1 | 1 | 0.5% | |
| 0.1 | 2 | 1.0% | |
| 0 | 3 | 1.5% |
| Distinct | 39 |
|---|---|
| Distinct (%) | 20.0% |
| Missing | 3 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 145.7128205 |
|---|---|
| Minimum | 0 |
| Maximum | 4154 |
| Zeros | 2 |
| Zeros (%) | 1.0% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13.5 |
| Q1 | 25 |
| median | 40 |
| Q3 | 80 |
| 95-th percentile | 633 |
| Maximum | 4154 |
| Range | 4154 |
| Interquartile range (IQR) | 55 |
Descriptive statistics
| Standard deviation | 413.5702356 |
|---|---|
| Coefficient of variation (CV) | 2.838255647 |
| Kurtosis | 51.81934142 |
| Mean | 145.7128205 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 6.491987871 |
| Sum | 28414 |
| Variance | 171040.3398 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 25 | 20 | 10.1% | |
| 15 | 20 | 10.1% | |
| 50 | 19 | 9.6% | |
| 40 | 18 | 9.1% | |
| 30 | 17 | 8.6% | |
| 60 | 13 | 6.6% | |
| 100 | 11 | 5.6% | |
| 20 | 11 | 5.6% | |
| 10 | 8 | 4.0% | |
| 80 | 7 | 3.5% | |
| Other values (29) | 51 | 25.8% |
| Value | Count | Frequency (%) | |
| 0 | 2 | 1.0% | |
| 10 | 8 | 4.0% | |
| 15 | 20 | 10.1% | |
| 20 | 11 | 5.6% | |
| 25 | 20 | 10.1% |
| Value | Count | Frequency (%) | |
| 4154 | 1 | 0.5% | |
| 2344 | 1 | 0.5% | |
| 2100 | 1 | 0.5% | |
| 1345 | 1 | 0.5% | |
| 1238 | 1 | 0.5% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 33.3% |
| Missing | 195 |
| Missing (%) | 98.5% |
| Memory size | 1.5 KiB |
| 0 | 3 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| 0 | 3 | 1.5% | |
| (Missing) | 195 | 98.5% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 66 |
| Missing (%) | 33.3% |
| Memory size | 1.5 KiB |
| no | |
|---|---|
| yes | |
| (Missing) |
| Value | Count | Frequency (%) | |
| no | 117 | 59.1% | |
| yes | 15 | 7.6% | |
| (Missing) | 66 | 33.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 155 |
| Missing (%) | 78.3% |
| Memory size | 1.5 KiB |
| no | |
|---|---|
| yes | |
| (Missing) |
| Value | Count | Frequency (%) | |
| no | 22 | 11.1% | |
| yes | 21 | 10.6% | |
| (Missing) | 155 | 78.3% |
| Distinct | 4 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 13 |
| Missing (%) | 6.6% |
| Memory size | 1.5 KiB |
| good | |
|---|---|
| moderate | |
| poor | 3 |
| absent | 1 |
| Value | Count | Frequency (%) | |
| good | 156 | 78.8% | |
| moderate | 25 | 12.6% | |
| poor | 3 | 1.5% | |
| absent | 1 | 0.5% | |
| (Missing) | 13 | 6.6% |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.5% |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 4.449494949 |
| Min length | 3 |
| Distinct | 45 |
|---|---|
| Distinct (%) | 24.1% |
| Missing | 11 |
| Missing (%) | 5.6% |
| Memory size | 1.5 KiB |
| Minimum | 2018-05-31 12:00:00 |
|---|---|
| Maximum | 2020-10-07 11:00:00 |
| Distinct | 79 |
|---|---|
| Distinct (%) | 69.3% |
| Missing | 84 |
| Missing (%) | 42.4% |
| Memory size | 1.5 KiB |
| Slatted | |
|---|---|
| Clear brash | 6 |
| Slight scouring | 2 |
| Badly silted. Low priority | 2 |
| Clear Brash | 2 |
| Other values (74) |
| Value | Count | Frequency (%) | |
| Slatted | 25 | 12.6% | |
| Clear brash | 6 | 3.0% | |
| Slight scouring | 2 | 1.0% | |
| Badly silted. Low priority | 2 | 1.0% | |
| Clear Brash | 2 | 1.0% | |
| Brash build up above dam | 2 | 1.0% | |
| Good size | 2 | 1.0% | |
| Good pathway in | 2 | 1.0% | |
| Maintenance review due Q1 2020 | 1 | 0.5% | |
| slight scouring | 1 | 0.5% | |
| Other values (69) | 69 | 34.8% | |
| (Missing) | 84 | 42.4% |
Unique
| Unique | 71 ? |
|---|---|
| Unique (%) | 62.3% |
Length
| Max length | 60 |
|---|---|
| Median length | 7 |
| Mean length | 12.58585859 |
| Min length | 3 |
| Distinct | 198 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| Minimum | 2019-08-03 18:37:53 |
|---|---|
| Maximum | 2020-10-07 15:13:58 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 172 |
| Missing (%) | 86.9% |
| Memory size | 1.5 KiB |
| gsmithadmin |
|---|
| Value | Count | Frequency (%) | |
| gsmithadmin | 26 | 13.1% | |
| (Missing) | 172 | 86.9% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 4.050505051 |
| Min length | 3 |
EditDate
Date
| Distinct | 197 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 KiB |
| Minimum | 2020-01-29 14:54:16 |
|---|---|
| Maximum | 2020-10-07 15:13:58 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 12 |
| Missing (%) | 6.1% |
| Memory size | 1.5 KiB |
| gsmithadmin |
|---|
| Value | Count | Frequency (%) | |
| gsmithadmin | 186 | 93.9% | |
| (Missing) | 12 | 6.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.51515152 |
| Min length | 3 |
| Distinct | 198 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1.709514809 |
|---|---|
| Minimum | -1.81663 |
| Maximum | -1.5606919 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | -1.81663 |
|---|---|
| 5-th percentile | -1.777469068 |
| Q1 | -1.757926072 |
| median | -1.728301006 |
| Q3 | -1.661295013 |
| 95-th percentile | -1.571073804 |
| Maximum | -1.5606919 |
| Range | 0.2559381 |
| Interquartile range (IQR) | 0.09663105881 |
Descriptive statistics
| Standard deviation | 0.06118858184 |
|---|---|
| Coefficient of variation (CV) | -0.03579295219 |
| Kurtosis | -0.03131510903 |
| Mean | -1.709514809 |
| Median Absolute Deviation (MAD) | 0.0369472 |
| Skewness | 0.7978542129 |
| Sum | -338.4839322 |
| Variance | 0.003744042547 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -1.758064559 | 1 | 0.5% | |
| -1.770853333 | 1 | 0.5% | |
| -1.774979703 | 1 | 0.5% | |
| -1.656785729 | 1 | 0.5% | |
| -1.758489443 | 1 | 0.5% | |
| -1.777843823 | 1 | 0.5% | |
| -1.5615099 | 1 | 0.5% | |
| -1.716003425 | 1 | 0.5% | |
| -1.758075588 | 1 | 0.5% | |
| -1.634090221 | 1 | 0.5% | |
| Other values (188) | 188 | 94.9% |
| Value | Count | Frequency (%) | |
| -1.81663 | 1 | 0.5% | |
| -1.81656 | 1 | 0.5% | |
| -1.81053 | 1 | 0.5% | |
| -1.79983 | 1 | 0.5% | |
| -1.783210321 | 1 | 0.5% |
| Value | Count | Frequency (%) | |
| -1.5606919 | 1 | 0.5% | |
| -1.5612588 | 1 | 0.5% | |
| -1.5615099 | 1 | 0.5% | |
| -1.5617738 | 1 | 0.5% | |
| -1.562119 | 1 | 0.5% |
| Distinct | 198 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.04383719 |
|---|---|
| Minimum | 51.98011 |
| Maximum | 52.07702522 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | 51.98011 |
|---|---|
| 5-th percentile | 52.01016617 |
| Q1 | 52.0287023 |
| median | 52.03841892 |
| Q3 | 52.06597563 |
| 95-th percentile | 52.07422232 |
| Maximum | 52.07702522 |
| Range | 0.09691521539 |
| Interquartile range (IQR) | 0.0372733309 |
Descriptive statistics
| Standard deviation | 0.02117500448 |
|---|---|
| Coefficient of variation (CV) | 0.000406868625 |
| Kurtosis | -0.8723273582 |
| Mean | 52.04383719 |
| Median Absolute Deviation (MAD) | 0.0138980384 |
| Skewness | -0.1004431877 |
| Sum | 10304.67976 |
| Variance | 0.0004483808146 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 52.03816216 | 1 | 0.5% | |
| 52.06783191 | 1 | 0.5% | |
| 52.02649249 | 1 | 0.5% | |
| 52.00221321 | 1 | 0.5% | |
| 52.02291011 | 1 | 0.5% | |
| 52.02355373 | 1 | 0.5% | |
| 52.03710575 | 1 | 0.5% | |
| 52.03334614 | 1 | 0.5% | |
| 52.06034333 | 1 | 0.5% | |
| 52.03748964 | 1 | 0.5% | |
| Other values (188) | 188 | 94.9% |
| Value | Count | Frequency (%) | |
| 51.98011 | 1 | 0.5% | |
| 52.00201133 | 1 | 0.5% | |
| 52.0020128 | 1 | 0.5% | |
| 52.00220427 | 1 | 0.5% | |
| 52.00221321 | 1 | 0.5% |
| Value | Count | Frequency (%) | |
| 52.07702522 | 1 | 0.5% | |
| 52.07656807 | 1 | 0.5% | |
| 52.0763655 | 1 | 0.5% | |
| 52.07602425 | 1 | 0.5% | |
| 52.07577705 | 1 | 0.5% |
| Distinct | 25 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.811130596 |
|---|---|
| Minimum | -2 |
| Maximum | 3.778151974 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.5 KiB |
Quantile statistics
| Minimum | -2 |
|---|---|
| 5-th percentile | 0.004321373783 |
| Q1 | 2.000043427 |
| median | 2.000043427 |
| Q3 | 2.176120211 |
| 95-th percentile | 3.191493414 |
| Maximum | 3.778151974 |
| Range | 5.778151974 |
| Interquartile range (IQR) | 0.1760767838 |
Descriptive statistics
| Standard deviation | 0.9906289171 |
|---|---|
| Coefficient of variation (CV) | 0.5469671372 |
| Kurtosis | 2.630265293 |
| Mean | 1.811130596 |
| Median Absolute Deviation (MAD) | 0.1760767838 |
| Skewness | -1.47733525 |
| Sum | 358.603858 |
| Variance | 0.9813456515 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2.000043427 | 65 | 32.8% | |
| 0.004321373783 | 30 | 15.2% | |
| 2.176120211 | 23 | 11.6% | |
| 2.079217436 | 22 | 11.1% | |
| 1.778223627 | 10 | 5.1% | |
| 2.361746718 | 9 | 4.5% | |
| 2.204147125 | 7 | 3.5% | |
| 2.30105171 | 5 | 2.5% | |
| 2.414990051 | 5 | 2.5% | |
| -2 | 3 | 1.5% | |
| Other values (15) | 19 | 9.6% |
| Value | Count | Frequency (%) | |
| -2 | 3 | 1.5% | |
| 0.004321373783 | 30 | 15.2% | |
| 1.778223627 | 10 | 5.1% | |
| 2.000043427 | 65 | 32.8% | |
| 2.079217436 | 22 | 11.1% |
| Value | Count | Frequency (%) | |
| 3.778151974 | 1 | 0.5% | |
| 3.602061077 | 1 | 0.5% | |
| 3.579784739 | 1 | 0.5% | |
| 3.426512888 | 1 | 0.5% | |
| 3.33344929 | 2 | 1.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| ObjectID | GlobalID | Select project | FR1_ProjectName | Asset ID: | Asset Type | Asset Description | Date Installed | Installed Cost (£) | Watercourse Type | Stream Width (m) | Land Drainage Consent Difficulty | Ecological Consent Difficulty | Average member length in Leaky Barrier (m) | Wood Diameter (cm) | Height of Leaky Barrier above bed (cm) | Height of Leaky Barrier above bank (cm) | Wood Species Used | Other Wood Species | Bund height (m) | Bund width (m) | Bund length (m) | Bund Material | Gully Block Length (m) | Gully Block Width (m) | Gully Block Material | Soil Equipment or Technique Used | Flood Efficacy | FR3 Area Units | FR3_AreaRough | Storage Created (m3) | FR3_AreaIncreasedLoss | Changed Flood Pathway? | Reduced Erosion? | Asset Condition | Date Assessed | Comments | CreationDate | Creator | EditDate | Editor | longitude | latitude | log10_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 883 | 33059012-1c4d-43c7-adb7-496972f3c9b4 | A017 | Shipston | A017_2006151117 | leaky_barriers | 9 | 2020-06-02 11:00:00 | 1 | ordinary | 3.0 | easy | n_a | 5.0 | 20.0 | 30.0 | 0.0 | willow_dead | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 135.0 | NaN | no | NaN | good | 2020-06-15 11:00:00 | NaN | 2020-06-15 10:18:01 | gsmithadmin | 2020-08-03 11:44:52 | NaN | -1.715078 | 52.069716 | 0.004321 |
| 1 | 1066 | 02b90a36-d984-4b36-a299-4fbbe884f7b2 | A017 | Shipston | A017_2008051630 | leaky_barriers | BLOCKPOTT*1 | 2020-08-05 11:00:00 | 260 | ordinary | 1.5 | easy | n_a | 3.0 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 40.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 16:44:24 | NaN | 2020-09-18 19:01:54 | gsmithadmin | -1.732871 | 52.026232 | 2.414990 |
| 2 | 1067 | 6f0e9956-8d95-4ebf-a540-9f0cabc735e9 | A017 | Shipston | A017_2008051627 | leaky_barriers | BLOCKPOTT*2 | 2020-08-05 11:00:00 | 260 | ordinary | 1.5 | easy | n_a | 3.5 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 30.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 16:44:36 | NaN | 2020-09-18 19:02:03 | gsmithadmin | -1.732574 | 52.026312 | 2.414990 |
| 3 | 1068 | a5d7435c-363e-41bf-ac2e-cea617acbfcd | A017 | Shipston | A017_2008051625 | leaky_barriers | BLOCKPOTT*3 | 2020-08-05 11:00:00 | 260 | ordinary | 1.5 | easy | n_a | 3.0 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 25.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 16:44:49 | NaN | 2020-09-18 19:02:11 | gsmithadmin | -1.732450 | 52.026399 | 2.414990 |
| 4 | 1069 | 01f0b340-5a4d-483d-91d0-7161b87d3ccb | A017 | Shipston | A017_2008051622 | leaky_barriers | BLOCKPOTT*4 | 2020-08-05 11:00:00 | 260 | ordinary | 2.0 | easy | n_a | 4.0 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 30.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 16:45:02 | NaN | 2020-09-18 19:02:50 | gsmithadmin | -1.732442 | 52.026492 | 2.414990 |
| 5 | 1058 | 7b72fa58-62c9-4c1c-9617-a3fb8bf7cd83 | A017 | Shipston | A017_2008051617 | leaky_barriers | BLOCKPOTT*5 | 2020-08-05 11:00:00 | 260 | ordinary | 1.0 | easy | n_a | 3.0 | NaN | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | ha | NaN | 25.0 | NaN | no | NaN | good | 2020-06-29 23:00:00 | Slatted | 2020-08-05 15:22:21 | NaN | 2020-09-18 19:02:22 | gsmithadmin | -1.732281 | 52.026592 | 2.414990 |
| 6 | 442 | 1d32eb4f-29cb-4dd9-8e9c-4d94d643dc02 | A017 | Shipston | A017_2002241950 | leaky_barriers | BLOCKPOTT01LB1 | 2017-10-10 12:00:00 | 60 | ordinary | 1.0 | easy | n_a | 2.5 | 10.0 | 5.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | low | ha | NaN | 10.0 | NaN | no | NaN | moderate | 2020-02-15 12:00:00 | Low priority | 2020-02-24 20:06:31 | gsmithadmin | 2020-02-28 07:24:22 | gsmithadmin | -1.731846 | 52.022910 | 1.778224 |
| 7 | 443 | 06539413-6f5b-4643-8dca-6e8940039a05 | A017 | Shipston | A017_2002242006 | leaky_barriers | BLOCKPOTT02LB2 | 2017-10-10 12:00:00 | 60 | ordinary | 1.0 | easy | n_a | 2.0 | 10.0 | 15.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | low | ha | NaN | 10.0 | NaN | NaN | NaN | moderate | 2020-02-15 12:00:00 | Silted, some scouring. Low Priority | 2020-02-24 20:13:57 | gsmithadmin | 2020-02-28 07:24:32 | gsmithadmin | -1.731913 | 52.023080 | 1.778224 |
| 8 | 444 | 2e6b604a-fca5-44f1-85e1-118e97dd4afd | A017 | Shipston | A017_2002242017 | leaky_barriers | BLOCKPOTT03LB3 | 2017-10-10 12:00:00 | 60 | ordinary | 1.5 | easy | n_a | 2.5 | 15.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | low | ha | NaN | 10.0 | NaN | no | NaN | moderate | 2020-02-15 12:00:00 | Silted. Low priority | 2020-02-24 20:21:28 | gsmithadmin | 2020-02-28 07:24:41 | gsmithadmin | -1.731838 | 52.023261 | 1.778224 |
| 9 | 445 | 3824078b-cb41-40f2-8e84-469b90340bcb | A017 | Shipston | A017_2002242021 | leaky_barriers | BLOCKPOTT04LB4 | 2017-10-10 12:00:00 | 60 | ordinary | NaN | easy | n_a | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | low | ha | NaN | 10.0 | NaN | no | NaN | moderate | 2020-02-15 12:00:00 | Badly silted. Low priority | 2020-02-24 20:25:54 | gsmithadmin | 2020-02-28 07:24:51 | gsmithadmin | -1.731857 | 52.023405 | 1.778224 |
Last rows
| ObjectID | GlobalID | Select project | FR1_ProjectName | Asset ID: | Asset Type | Asset Description | Date Installed | Installed Cost (£) | Watercourse Type | Stream Width (m) | Land Drainage Consent Difficulty | Ecological Consent Difficulty | Average member length in Leaky Barrier (m) | Wood Diameter (cm) | Height of Leaky Barrier above bed (cm) | Height of Leaky Barrier above bank (cm) | Wood Species Used | Other Wood Species | Bund height (m) | Bund width (m) | Bund length (m) | Bund Material | Gully Block Length (m) | Gully Block Width (m) | Gully Block Material | Soil Equipment or Technique Used | Flood Efficacy | FR3 Area Units | FR3_AreaRough | Storage Created (m3) | FR3_AreaIncreasedLoss | Changed Flood Pathway? | Reduced Erosion? | Asset Condition | Date Assessed | Comments | CreationDate | Creator | EditDate | Editor | longitude | latitude | log10_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188 | 623 | 0dcabf5f-35c5-468f-b796-6895259f1549 | A017 | Shipston | A017_2004221656 | leaky_barriers | KNEELONG42LB42 | 2018-10-22 11:00:00 | 100 | ordinary | 1.5 | easy | n_a | 3.0 | 15.0 | 30.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 50.0 | NaN | yes | NaN | good | 2020-04-21 23:00:00 | Some build up behind dam | 2020-04-22 16:00:44 | NaN | 2020-08-15 13:39:31 | gsmithadmin | -1.756386 | 52.068120 | 2.000043 |
| 189 | 619 | 4a1f3841-8431-40a0-8da1-2c8b6e2a2f9f | A017 | Shipston | A017_2004211150 | leaky_barriers | KNEELONG43LB43 | 2020-04-21 11:00:00 | 100 | ordinary | 1.5 | easy | n_a | 3.0 | 15.0 | 60.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 50.0 | NaN | no | NaN | good | 2020-04-21 23:00:00 | NaN | 2020-04-21 10:58:28 | NaN | 2020-08-15 13:39:42 | gsmithadmin | -1.756457 | 52.067832 | 2.000043 |
| 190 | 618 | 2c130aff-9e62-4e69-a852-4b04881bc2b6 | A017 | Shipston | A017_2004211152 | leaky_barriers | KNEELONG44LB44 | 2018-10-21 11:00:00 | 100 | ordinary | 1.0 | easy | n_a | 2.5 | 15.0 | 45.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 45.0 | NaN | no | NaN | good | 2020-04-21 23:00:00 | Rebar used | 2020-04-21 10:58:11 | NaN | 2020-08-15 13:39:49 | gsmithadmin | -1.756359 | 52.067583 | 2.000043 |
| 191 | 617 | 02a1780b-5ee0-4b98-babb-754fa2fadb00 | A017 | Shipston | A017_2004211155 | leaky_barriers | KNEELONG45LB45 | 2018-10-21 11:00:00 | 100 | ordinary | 1.0 | easy | n_a | 2.5 | 15.0 | 45.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 80.0 | NaN | no | NaN | good | 2020-04-21 23:00:00 | NaN | 2020-04-21 10:57:57 | NaN | 2020-08-15 13:40:00 | gsmithadmin | -1.756378 | 52.066720 | 2.000043 |
| 192 | 629 | 9600a2c4-fb34-44a3-809e-99c0101bb269 | A017 | Shipston | A017_2004221625 | leaky_barriers | KNEELONG46LB46 | 2018-10-22 11:00:00 | 100 | ordinary | 1.5 | easy | n_a | 3.0 | 15.0 | 60.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 50.0 | NaN | no | NaN | good | 2020-04-21 23:00:00 | NaN | 2020-04-22 16:01:31 | NaN | 2020-08-15 13:40:10 | gsmithadmin | -1.756140 | 52.066347 | 2.000043 |
| 193 | 628 | 01fb3d79-a96f-401e-92af-c5358ad1ec1f | A017 | Shipston | A017_2004221628 | leaky_barriers | KNEELONG47LB47 | 2020-04-22 11:00:00 | 100 | ordinary | 1.5 | easy | n_a | 3.5 | 15.0 | 60.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 50.0 | NaN | no | NaN | good | 2020-04-21 23:00:00 | NaN | 2020-04-22 16:01:25 | NaN | 2020-08-15 13:40:20 | gsmithadmin | -1.756129 | 52.066076 | 2.000043 |
| 194 | 627 | 224efb9a-5a7a-4f12-8ebf-3eb368459314 | A017 | Shipston | A017_2004221633 | leaky_barriers | KNEELONG48LB48 | 2018-10-22 11:00:00 | 100 | ordinary | 1.5 | easy | n_a | 4.0 | 15.0 | 60.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 60.0 | NaN | no | NaN | good | 2020-04-21 23:00:00 | NaN | 2020-04-22 16:01:20 | NaN | 2020-08-15 13:40:28 | gsmithadmin | -1.756120 | 52.065675 | 2.000043 |
| 195 | 626 | ce4a7b74-c608-4cd6-9d9a-fbba4bca2d53 | A017 | Shipston | A017_2004221636 | leaky_barriers | KNEELONG49LB49 | 2018-10-22 11:00:00 | 100 | ordinary | 1.5 | easy | n_a | 3.5 | 15.0 | 45.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 45.0 | NaN | no | NaN | good | 2020-04-21 23:00:00 | NaN | 2020-04-22 16:01:14 | NaN | 2020-08-15 13:40:37 | gsmithadmin | -1.755944 | 52.065577 | 2.000043 |
| 196 | 625 | fe9b5dee-2d45-4ee1-a16f-d3fb2d967640 | A017 | Shipston | A017_2004221639 | leaky_barriers | KNEELONG50LB50 | 2020-04-22 11:00:00 | 100 | ordinary | 1.5 | easy | n_a | 3.0 | 15.0 | 45.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | high | ha | NaN | 60.0 | NaN | no | NaN | good | 2020-04-22 11:00:00 | Brash to be cleared | 2020-04-22 16:01:06 | NaN | 2020-08-15 13:40:46 | gsmithadmin | -1.755823 | 52.065232 | 2.000043 |
| 197 | 624 | cb9090f8-1682-41b8-ba76-04028f57a6a9 | A017 | Shipston | A017_2004221644 | leaky_barriers | KNEELONG51LB51 | 2020-04-22 11:00:00 | 100 | ordinary | 1.5 | easy | n_a | 3.0 | 15.0 | 45.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | moderate | ha | NaN | 70.0 | NaN | no | NaN | moderate | NaT | Minor repair needed. Banding, re-bedding | 2020-04-22 16:00:56 | NaN | 2020-08-15 13:41:04 | gsmithadmin | -1.756003 | 52.064400 | 2.000043 |